create  external table jms_ods.tab_outlets_abnormal_config_hi
(
       id                           string comment '主键id',
       network_code                 string comment '网点编码',
       network_name                 string  comment '网点名称',
       effect_start_time            timestamp comment '有效开始日期',
       effect_end_time              timestamp comment '有效结束日期',
       create_by                    string  comment '创建人',
       create_time                  timestamp comment '创建时间',
       update_by                    string comment '更新人',
       update_time                  timestamp comment '更新时间',
       is_del                       string comment '是否删除'
)comment '异常报备网点配置表'
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/dw/hive/jms_ods.db/external/tab_outlets_abnormal_config_hi'
tblproperties (
      'parquet.column.index.access'= 'true'
);
jms_dim__dim_tab_outlets_abnormal_config_base_hi